When i export data from MySQL(server 5.0) i get followng error.

SQLSTATE: 01004 [MySQL][ODBC 3.51 Driver][mysqld-4.1.18-nt]String data,
right truncated

can sombody explain why this is happenning and possible solution!!!

consider it as a bit urgent!!!

Kuldeep wrote:
> When i export data from MySQL(server 5.0) i get followng error.
>
> SQLSTATE: 01004 [MySQL][ODBC 3.51 Driver][mysqld-4.1.18-nt]String data,
> right truncated
>
> can sombody explain why this is happenning and possible solution!!!

Perhaps it is related to this bug:
http://bugs.mysql.com/bug.php?id=15310

The bug has status "verified" which means MySQL AB has been able to
reproduce it, but does not have a fix.

The bug report claims that this error does not occur with a slightly
older version of the ODBC driver; the reporter tested 3.51.11 and
3.51.9. You could try to find a download for one of these versions.

Regards,
Bill K.